2017-01-12 - 28544 - Service Request - EMEA OSA100 SO Exclusion #BWProductionIssues
Service Request
28544 - EMEA osa100 SO exclusionProblem Summary
Need to find why the Sales order 3196719 is shown in Open order reports when it is completely invoiced in SAP.
Admin Info
| Purpose |
Need to find why the order 3196719 is shown in Open order reports when it is completely invoiced in SAP |
| Requested by |
Pierre Pazgrat |
| Issue Date |
01-12-2017 |
| Resolved by |
Naveen G |
| Resolved Date |
01-15-2017 |
| Document Status |
Complete |
Detailed Problem Description
EMEA OSA100 – ZEM_OOCON_Q001
And the same is being shown in the report for the month of September 2016. But in sap, the order is delivered and closed. Actually, this order shouldn’t be shown in the report. Can you please take a look?
Solution Analysis and Recommendations
Sales Order 3196719 is completely delivered & Invoiced in ECC, but it is still shown in the reports. The reason is that delivery(83533500) is created initially for the SO 3196719 & then it was deleted. Later delivery 83518383 was created & the same is invoiced. The deleted delivery triggered negative values in BW causing the PGI Qty to be negative values.
A Sales order is said to be closed in open order infocube, if both open quantity & PGI quantity are zeroes. Since the PGI qty’s are negative, the order is still getting extracted into open order infocube & is shown as open in all the OSA reports.
Resolution
Reloading the Sales order, delivery and invoice from ECC fixed the issue & order is not shown on OSA reports anymore.
Release Information
None